create external table jms_dm.dm_agent_operate_bi_dt (
manage_code string comment'管理大区code',
manage_name string comment'管理大区名字',
agent_code string comment'代理区code',
agent_name string comment'代理区名字',
qxt_bill_count bigint comment'七星潭平台业务量',
thd_bill_Count bigint comment'桃花岛平台业务量',
zjs_bill_Count bigint comment'紫金山平台业务量',
xyf_bill_Count bigint comment'逍遥峰平台业务量',
qt_bill_Count bigint comment'其它平台业务量',
pick_waybill_cnt bigint comment'收件量',
departure_total bigint comment'发车总个数',
punctuality_sum bigint comment'准时发车个数',
not_punctuality_sum bigint comment'晚点发车个数',
arrival_total bigint comment'干线到车数',
arrival_late_sum bigint comment'干线到车晚点数',
arrival_not_late_sum bigint comment'干线准时到车个数',
deliver_waybill_sum bigint comment'派件总量',
sign_cnt bigint comment'签收总量',
new_network_cnt bigint comment'新增网点个数',
total_network_cnt bigint comment'网点总数',
not_operate_network_cnt bigint comment'未运营网点数',
business_date date comment'日期'
)
    COMMENT  '平台业务量——代理区报表'
    PARTITIONED BY ( dt STRING COMMENT '日期')
    STORED AS PARQUET
    LOCATION '/dw/hive/jms_dm.db/external/dm_agent_operate_bi_dt'
    TBLPROPERTIES (
        'discover.partitions' = 'false',
        'parquet.column.index.access' = 'true'
        );
alter table jms_dm.dm_agent_operate_bi_dt add columns (
jdw_bill_count int comment '极地湾平台业务量'
    ) cascade ;